#coding=utf-8

class SO:
    strDbTblInit = '''create table if not exists tblSaleOrder
                    {
                    id varchar(20) NOT NULL,
                    cust_name text,
                    deliveryInfo text,
                    date date,
                    total float,
                    paid float,
                    unpaid float,
                    discount float,
                    handling varchar(20),
                    memo text
                    }'''
                    
    strDbTblInit2 ='''create table if not exists tblSaleInfo
                    {
                    so_id varchar(20),
                    pro_id int(8),
                    num float,
                    unit_price float,
                    total float,
                    gross_profit float, 
                    }'''
    def __init__(self):
        pass
    
    def dbTbl
    def dbInit(self):
        pass